package com.syy.spider.dao;

import com.syy.spider.pojo.Picture;
import com.syy.spider.pojo.Pyq;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface PyqMapper {
    int insertPyq(@Param("title") String title, @Param("con") String con,
                  @Param("url") String url, @Param("username") String username,
                  @Param("date") String date);

    List<Pyq> selectAll();

    Picture selectPictureByUrl(@Param("url") String url);

    int dianzan(@Param("id") int id);

    int cai(@Param("id") int id);

    List<Pyq> selectOrderByZan();
}
